<?php
/* wwwschool project

Copyright (C) 2009  Phillip Aldridge
Email : info@imi21.com
Web site http://www.imi21.com

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
*/


/**
 *  File : addModuleLessonUpdate.php
 *  called only via ajax 
 *  
 *  requires
 *  @ id = module_id
 *  @ lesson_id = lesson_id
 */  


checkSession();
if ($session->userType() > 3) // admin, head master & teacher
{
  die('Wrong user rights');
  exit;
}

$date=date("Y-m-d H:i:s");

// check if module exists
// check if lesson exists

// get next position
$db=new WS3_Database();
$module_id=$_POST['id'];
$lesson_id=$_POST['lesson_id'];

$q="SELECT MAX(position) AS p 
 FROM `module2lesson`
 WHERE 1 AND `lesson_id` = '$lesson_id' LIMIT 1";
 

if ($db->query($q) && $db->nextRecord() )
{
  $position=$db->f('p')+1;
}

// insert into table
$db=new WS3_Database();
$q="INSERT INTO `module2lesson`
(id,lesson_id,module_id,position )
VALUES (NULL,'$lesson_id','$module_id','$position')";

 
if ($db->query($q)){
  if (W3DEBUG) array_push($GLOBALS['W3DEBUG'],"Add module to lesson ok id=$lesson_id");
}else{
  if (W3DEBUG) array_push($GLOBALS['W3DEBUG'],"Add module to lesson failed id=$lesson_id");
}

 
 $id=$lesson_id;
 include 'listLessonModules.php';

?>
